USE AdventureWorks2008
SELECT Name, GroupName FROM HumanResources.Department